package com.tyl.dao.provider;

import com.tyl.pojo.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProviderDao {

    /**
     *  通过供应商名称、编码获取供应商列表-模糊查询-providerList
     * **/
    public List<Provider> getProviderList(Connection connection,String proCode,String proName) throws SQLException;


    /**
     * 通过proId获取Provider
     * **/
    Provider getProviderById(Connection connection, String id) throws SQLException;

    /**
     * 添加供应商
     * **/
    int addProvider(Connection connection, Provider provider);

    /**
     * 删除供应商
     * **/
    int deleteProvider(Connection connection,String pId) throws SQLException;

    /**
     * 修改供应商信息
     * **/
    int updateProvider(Connection connection,Provider provider);
}
